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