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