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