UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rImApRf7+JIIWDRT7vVbNoxIq7jS3zL/E+cVGH7esRE='
WHERE
key_id = '5f55f4a47b2595ac5275e21e7490307508934489ede4bdb8795a20c11e781d85'
AND (
token = 'rImApRf7+JIIWDRT7vVbNoxIq7jS3zL/E+cVGH7esRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)