UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4JLIZXM1drE1gwm4rNM0beqcIzSic5osXtWwHW6BBO0='
WHERE
key_id = '08c28d2b70d92f4e5d915bb7cefc90dc77bd99a108e88939fb901872dea8fe41'
AND (
token = '4JLIZXM1drE1gwm4rNM0beqcIzSic5osXtWwHW6BBO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)