UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qLNeRMwfPl7rhXbXpW80MnIeBUECjeKp+W8h7D2XkqM='
WHERE
key_id = 'e4440ca59723752233e7d9685613c547752092ec8d81c399618d5b444cdbf04b'
AND (
token = 'qLNeRMwfPl7rhXbXpW80MnIeBUECjeKp+W8h7D2XkqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)