UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WFiGo4EKqBwXe6wILMmVFWB+Xcd+IjWxXKAZ/f3hcyE=' 
WHERE 
  key_id = 'eac197a204e4040b598318d818611e3ae592b6d4c97b51bf739f177de00e338d' 
  AND (
    token = 'WFiGo4EKqBwXe6wILMmVFWB+Xcd+IjWxXKAZ/f3hcyE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020