UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2Aj2TkJh9l/L210FnC8gUSO+CA0Z5VezJQNUsCSdd1c=' 
WHERE 
  key_id = '0200a866ee560f847eda284cd46c1af8ed8d566b33932be8f6821940949700c5' 
  AND (
    token = '2Aj2TkJh9l/L210FnC8gUSO+CA0Z5VezJQNUsCSdd1c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021