UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZ64GUiYcNgijqORQntlqYJMoVYjpEY8PxI0j1mPstw='
WHERE
key_id = '2d7a35f59b4e4d5195aa98344e7015fedf47df16138049f7a2a3e17def1d8198'
AND (
token = 'JZ64GUiYcNgijqORQntlqYJMoVYjpEY8PxI0j1mPstw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)