UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dQy2PQC1W84z+MMWR5h7gVOJ3Fg7KyVYzdRPRZpoahw='
WHERE
key_id = 'e8bef78d4b3f24a6478be535cfba2c13f900ea78fdc293141726b18a2723e832'
AND (
token = 'dQy2PQC1W84z+MMWR5h7gVOJ3Fg7KyVYzdRPRZpoahw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)