UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9HUYUF7I3YUBrMxx1zgcdfPTqN+WE/ATtBib7YJxxiw='
WHERE
key_id = 'f95fae67a123d4a05bec8a54ddcda6e81a6b857a3268383115dcf39da80d01ab'
AND (
token = '9HUYUF7I3YUBrMxx1zgcdfPTqN+WE/ATtBib7YJxxiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)