UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pg8AQmbpo4ZJ3UxfnFk0lCPE0lnJJfvonLIBhKXmhCo='
WHERE
key_id = '0f564e8c23057ac23307d78851c8561a574499c6e520e46a65254973c104b2b4'
AND (
token = 'pg8AQmbpo4ZJ3UxfnFk0lCPE0lnJJfvonLIBhKXmhCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)