UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59bB8FRkdpp6QLIG3zo0qkyIkKytfzNTE8MkwXwx3Jw='
WHERE
key_id = 'c37a57ce408e0a0842e9e6c7679a4e880a70eaf04a0c16e3a4f61e9775957a47'
AND (
token = '59bB8FRkdpp6QLIG3zo0qkyIkKytfzNTE8MkwXwx3Jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)