UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pbJEpPbGW8ZGWAXWpJ0RDLlpQm1k5981Y1lnZSD48qc=' 
WHERE 
  key_id = '7e5405a57f631ff0f1b7ec5c025081d9b7af6fecf9a4c9654fe25ce4b63e027c' 
  AND (
    token = 'pbJEpPbGW8ZGWAXWpJ0RDLlpQm1k5981Y1lnZSD48qc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031