UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kL64eqPtuqh1AezUgk60Fvs5A8GUkSm5VtHj0uuzg4M='
WHERE
key_id = 'a596a4583e8264af67705c75e270cde05c9297443b6fe831b55ec3742e85d03f'
AND (
token = 'kL64eqPtuqh1AezUgk60Fvs5A8GUkSm5VtHj0uuzg4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)