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