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