UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7sVlHjN5EqkwBipsjhaE+g36SMUBgz0PqaS4OL+5RnQ='
WHERE
key_id = 'debb3b7a97899ff37ca173873ba03f75f9b72a75fc9e2b482b1255aba6e2195e'
AND (
token = '7sVlHjN5EqkwBipsjhaE+g36SMUBgz0PqaS4OL+5RnQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)