UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5AYBpkaFvzFqMYf/wDKm8iHvH0NL+B9oOL6k/EL5lSk=' 
WHERE 
  key_id = 'affea9efbbc5e1c7572b6902cb89745da12101300d8747ae344a20b259ac99a9' 
  AND (
    token = '5AYBpkaFvzFqMYf/wDKm8iHvH0NL+B9oOL6k/EL5lSk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020