UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+e7WoQWH0ZWzz1mnnYU8OhRGYU0N2OFdG/W7TejAYSA='
WHERE
key_id = '97b5c952e15cd78ae56a9bef3fb9b82731dc8f6b6a53cef14e7a0711e5dfb7ba'
AND (
token = '+e7WoQWH0ZWzz1mnnYU8OhRGYU0N2OFdG/W7TejAYSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)