UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fTWHaXlBrs5/4J/LaxMXjazcWH4uLlXNsrKHol5rsHw='
WHERE
key_id = 'fcfd92b9654c4dd80905f2e084b95b4341c23b7298ab3953b95cf28befb115a2'
AND (
token = 'fTWHaXlBrs5/4J/LaxMXjazcWH4uLlXNsrKHol5rsHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)