UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1i9dYpPvXcQE4R8A5L2xennF7eNonfxiovKRI1TCLp8='
WHERE
key_id = '19ca96123d301eec8eca73542ab96486f469155db43d1da3014a739829a7c3f3'
AND (
token = '1i9dYpPvXcQE4R8A5L2xennF7eNonfxiovKRI1TCLp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)