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