UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y/YXux+26xZogWbA2iBQEpMJppBkT8kEk3kLkYlfNnQ='
WHERE
key_id = 'e839d6ba7ace43b20b121257f9fcb622a65b037feefdcc623cd11c4b5811f688'
AND (
token = 'Y/YXux+26xZogWbA2iBQEpMJppBkT8kEk3kLkYlfNnQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)