UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kNg6WofYAAuocMd0JB3Y81we4lXK2NZ5I6A08VSjywg='
WHERE
key_id = '0e03a3fb6e1a0898837d3a8ad37d6874eef46c0bb445ad6797afd7107d1cf3a1'
AND (
token = 'kNg6WofYAAuocMd0JB3Y81we4lXK2NZ5I6A08VSjywg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)