UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EPVC1qPILL2bZF0lL67p3LU2QfQdvvYSXa0JrFA1WzY='
WHERE
key_id = 'c55bdae10120faa38e58718308a61e4fac66063b551bf9a12bc2b3ca48e350b5'
AND (
token = 'EPVC1qPILL2bZF0lL67p3LU2QfQdvvYSXa0JrFA1WzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)