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