UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f6NANvGMoeNGGTI+I5UAz+KxhIRkGYdWUFV79a4lZrw='
WHERE
key_id = '0a12a89225238d179366b86797824c89cf7b38807478eab9386cf1cdc0807da0'
AND (
token = 'f6NANvGMoeNGGTI+I5UAz+KxhIRkGYdWUFV79a4lZrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)