UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'txLU7ypLhTrlO6ZS0rjJxR1OI6R5OCDXxyT/LuRaHpw='
WHERE
key_id = '6898b5ec15bee98f1c1d46b02d91411a51be0f35d33f44d52ddf8b984c6d549e'
AND (
token = 'txLU7ypLhTrlO6ZS0rjJxR1OI6R5OCDXxyT/LuRaHpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)